use homework;

-- 创建表
drop table if exists user_clicklog;

create table user_clicklog (
	user_id string,
	click_time string
) row format delimited fields terminated by ",";


-- 加载数据
load data local inpath '/root/homework/clicklog.dat' into table user_clicklog;
